#! /user/bin/env python
import pymysql

config = {
    'host':'localhost',
    'port':3306,
    'user':'root',
    'passwd':'MeiX2017.',
    'charset':'utf8mb4',
    'cursorclass':pymysql.cursors.DictCursor
}
conn = pymysql.connect(**config)
conn.autocommit(1)
cursor = conn.cursor()
#
# data_sql = "USE meix_dev;"
#
# sql = "SELECT a.`UserName`,a.`ChiSpelling`,a.`CompanyCode` " \
# 	  "FROM `ia_user` as a INNER JOIN `comb_create` as b on a.`ID` = b.`UID` " \
# 	  "WHERE b.`ID` = '1';"
